exec sp_MSforeachtable '
ALTER TABLE ? REBUILD PARTITION = ALL
WITH 
(DATA_COMPRESSION = PAGE
)'
